Appendix A: Importing Students

A typical workflow includes these tasks:

1. Log In to ConnectED
2. Create a Teacher Account
3. Create Class(es)
4. Import Student Information into ConnectED
5. Add Students to ConnectED Class(es)

KEY POINTS: You must Create a Class before you can Add Students, and you must Import Students before you can Add them to a Class.

You import Student Information into ConnectED using a Microsoft Excel® spreadsheet. This process creates a Username and Password for each Student and, optionally, associates Students with your Redemption Code.

Imported Students become Available to add to Classes when:

• You include a Redemption Code during the Import Student process

OR

• The Student Redeems a Redemption Code

Best Practice! Including a Redemption Code during the Import Students process (1) creates a Student Account, (2) adds the related item to the Students’ Bookbags, and (3) makes the Students immediately available to add to your Class.

From the User Management: Import Users from Excel page:

1. Click Download Student Template.

ConnectED displays the Opening import_students.xls dialog box (Figure 4).

Figure 4.  Download Excel Spreadsheet

Best Practice! Select Save File to download the spreadsheet to your computer. Be sure that you know where your computer saves downloaded files. You can then move the file to a directory of your choosing and rename the file, if desired.

1. Open the spreadsheet using Microsoft Excel®.
2. Complete the file according to the following specifications (Table 1, or click the Read Detailed Instructions button for online help).

See Figure 5 for a sample completed spreadsheet (Show Me!).

3. Save the file.

Table 1 Field Specifications
Field Name	Required (R) or Optional (O)	Specifications
Last Name	R	At least one character required; up to 50 characters; allowable special characters: space, apostrophe, hyphen
First Name	R	At least one character required; up to 50 character; allowable special characters: space, apostrophe, hyphen
Middle Initial	O	One character only
Gender	R	M, F
Grade Level	R	PK, K, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12
Disability Flag	O	Y, N
Free Lunch Eligibility	O	Y, N
Limited English	O	Y, N
Migrant Status	O	Y, N
Race	O	Native American, African-American, Asian/Pacific Islander, White/Caucasian, Hispanic
Student ID	R	At least one character required; up to 50 characters; any character allowed

Figure 5.  Import Students Spreadsheet Showing Required Fields Completed

• Select the Account, enter the optional Redemption Code, and browse your local computer to select the File to upload.

NOTE: Each Master Code for Student Materials enables you to create a Redemption Code, which your Students will use to create a Student Account and to add ConnectED Content to their online Bookbags.

A Redemption Code is a 12-digit alphanumeric code in the following format:

[4 characters]-[4 characters]-[4 characters]

1. Click Check File for Errors.

ConnectED checks the file for errors.

NOTE: Correct any reported file errors, if necessary, and repeat step 3.

If the file contains no errors, ConnectED displays the Complete Import button (Figure 6, Show Me!).

Figure 6.  Complete Import

2. Click the Complete Import button.

ConnectED displays the Import Users from a File: Import Results dialogue box (Figure 7).

CAUTION!! YOU MUST SAVE THIS FILE.

Figure 7.  Import Users from a File: Import Results

3. Click Save Imported User List.

ConnectED displays the Opening imported_students.xls dialogue box (Figure 7, above).

4. Ensure that you are saving the file. Click the OK button.

ConnectED saves the file on your computer.

Best Practice! Be sure that you know where your computer saves downloaded files. You can then move the file to a directory of your choosing and rename the file, if desired. Make sure to note the new location and name you assign to the file.

The new spreadsheet contains three additional columns: (1) Username, (2) Password, and (3) Redemption Code if you entered it in step 3, above

Distribute this information to your Students.

You are now ready to add Students to a Class.